DB: decent_gpp_mars_dw
|
Real-time top 10 slow queries (last 15 seconds) - Updated at: 11/2/2026 3:43:27 AM
|
| Query |
Last Time (ms) |
Min Time (ms) |
Max Time (ms) |
| No queries in the last 15 seconds. |
DB: decent_gpp_mars_dw
|
Real-time top 10 quick queries (last 15 seconds) - Updated at: 11/2/2026 3:43:28 AM
|
| Query |
Last Time (ms) |
Min Time (ms) |
Max Time (ms) |
SELECT tnx_id ,order_id FROM tbl_tallybox_sign _archive_2 ORDER BY tnx_id OFFSE T 0 ROWS FETCH NEXT 10 ROWS ONLY
|
2.696 |
2.696 |
2.696 |
SELECT SUM(row_count ) AS fast_counter FROM sys.dm_db _partition_stats WHERE (object_i d = OBJECT_ID('tbl_tallybox_sign _archive_1')) AND (index_id < 2)
|
4.438 |
4.438 |
4.438 |
SELECT TOP(10) st.text AS Quer yText, qs.last_elapsed_time / 10 00.0 AS LastTimeMs, qs.min_elaps ed_time / 1000.0 AS MinTimeMs, q s.max_elapsed_time / 1000.0 AS M axTimeMs, qs.last_execution_time AS LastRunTime, DB_NAME(CAST(pa .value AS INT)) AS DatabaseName FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_te xt(qs.sql_handle) st CROSS APPLY sys.dm_exec_plan_attributes(qs .plan_handle) pa WHERE qs.last_e xecution_time > DATEADD(SECOND, -15, GETDATE()) AND st.text LIKE '%tbl_%' AND pa.attribute = 'db id' AND DB_NAME(CAST(pa.value AS INT)) = 'decent_gpp_mars_dw' OR DER BY qs.last_elapsed_time DESC
|
924.608 |
924.608 |
924.608 |
|